SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_VerifyEmployee]
    (
      @JOL_Employee_Account VARCHAR(50),
      @JOL_Employee_VerifyStatus VARCHAR(50),
      @JOL_Employee_VerifyUser VARCHAR(50)
    )
AS 
    UPDATE  dbo.JOL_Employee
    SET     JOL_Employee_VerifyStatus = @JOL_Employee_VerifyStatus,
            JOL_Employee_VerifyTime = GETDATE(),
            JOL_Employee_VerifyUser = @JOL_Employee_VerifyUser
    WHERE   JOL_Employee_Account = @JOL_Employee_Account
GO
